IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'ColumbusAdm' AND TABLE_NAME = 'LookupRIIndicator') BEGIN
    DROP VIEW [ColumbusAdm].[LookupRIIndicator]
END
GO

CREATE VIEW [ColumbusAdm].[LookupRIIndicator]   
AS        
	SELECT LookupCategoryId AS Category,
	LookupId AS Id,
	LookupRef AS Reference,
	CultureCode,
	LookupName AS Name,
	DefaultYN AS IsDefault,
	SortOrder,
	SystemYN AS IsSystem,
	DeactiveYN AS IsDeactive,
	ParentLookupCategoryId,
	ParentLookupId,
	ParentLookupLanguageCode 
	FROM GLLookup 
	WHERE LOOKUPCATEGORYID = 'COVERAGERIIND' AND CultureCode = 'en-GB'	
GO
